CUBE CONNECT Edition Help

CubeConvert.exe

The CubeConvert.exe utility is provided inside the installation folder: "C:\Program Files\Bentley\CUBE7\CubeConvert.exe" and it can be run externally through a command line and within a Pilot or user program in CUBE (a GUI is not provided with the executable but tools within the toolbox provides these functionalities through GUI).

Syntax and Usage

The CubeConvert utility provides the following tools with the purpose of making easier the conversion / interface between the new and previous versions of the software.

The following arguments can be used to specify additional options. These are non-positional flags.

Argument Short option Description
--format-option -f Format Option. Supported formats are the below:
  • net-7to6
  • net-6to7
  • filegdb-net-6to7
  • mat-7to6
  • mat-6to7
  • transit-system-7to6
  • transit-system-6to7
  • transit-7to6
  • transit-6to7
  • nontransit-7to6
  • nontransit-6to7
  • toll-7to6
  • toll-6to7
  • junction-7to6
  • junction-6to7
  • turnpenalty-7to6
  • turnpenalty-6to7
  • zonal-reference
--source -s Source name
--destination -d Destination name
--network-name -n CUBE 7 network name
--toll-set-name -o CUBE 7 toll set name
--non-transit-network-name -x CUBE 7 non-transit network name in the database
--transit-network-name -t CUBE 7 transit network name in the database
--junction-set-name -j CUBE 7 junction set name
--turn-penalty-set-name -p CUBE 7 turn penalty set name
--zonal-reference-name -z CUBE 7 zonal reference name
--line-file -l CUBE 6 line (.lin) file path
--compression -c CUBE 7 output matrix compression level
--srid -i Spatial reference ID
--help -h Print help

The input and output files specification are non- positional and they are expressed as in the examples below.

Conversion option Input Output Description Example
net-6to7 CUBE 6 binary NET network CUBE 7 SQLite highway network Option converting the highway network from CUBE 7 SQLite to CUBE 6 binary network. Any geometry will be lost in the conversion.
"C:\Program Files\Bentley\CUBE7\CubeConvert.exe" -f net-6to7 -s "NetFile.NET" -d "Cubetown.sqlite" -n "NoBuild"
net-7to6 CUBE 7 SQLite highway network CUBE 6 binary NET network Option converting the highway network from CUBE 7 SQLite to CUBE 6 binary network. Any geometry will be lost in the conversion.
"C:\Program Files\Bentley\CUBE7\CubeConvert.exe" -f net-7to6 -s "Cubetown.sqlite" -n "NoBuild" -d "Cubetown.net"
filegdb-net-6to7 CUBE 6 Geodatabase CUBE 7 SQLite

Option converting the highway network from a CUBE 6 Geodatabase dataset to a CUBE 7 SQLite network.

If the output network already exists in an existing SQLite database, then the tool will return the following error:

Existing network with name: 'Network_Name'.

Note: The "Network_Name" must be the same both in the input GDB and in the output SQLite file.
"C:\Program Files\Bentley\CUBE7\CubeConvert.exe" -f filegdb-net-6to7 -n "Highway" -s "Cubetown.gdb"  -d "Cubetown_from_gdb.sqlite"
mat-6to7 CUBE 6 matrix file (.MAT) CUBE 7 matrix file (.cube-matrix) Option converting the matrix file from CUBE 6 binary format to CUBE 7.
"C:\Program Files\Bentley\CUBE7\CubeConvert.exe" -f mat-6to7 -s "HOURLYTRIPS.mat" -d "HOURLYTRIPS.cube-matrix"
mat-7to6 CUBE 7 matrix file (.cube-matrix) CUBE 6 matrix file (.MAT) Option converting the matrix file from CUBE 7 to CUBE 6 binary format.
"C:\Program Files\Bentley\CUBE7\CubeConvert.exe" -f mat-7to6 -s "HighwaySkims.cube-matrix" -d "HighwaySkimsC2.mat"
transit-system-6to7 CUBE 6 PT system file (.pts) CUBE 6 SQLite system data Option converting the PT system file from CUBE 6 text format to CUBE 7 data associated to a roadway network in the database.
"C:\Program Files\Bentley\CUBE7\CubeConvert.exe" -f transit-system-6to7 -s "SystemFile.pts" -d "Cubetown.sqlite" -n "NoBuild"
transit-system-7to6 CUBE 7 database with transit system data CUBE 6 PT system file (.pts) Option converting the PT system data associated to the CUBE 7 network to the CUBE 6 PTS text file.
"C:\Program Files\Bentley\CUBE7\CubeConvert.exe" -f transit-system-7to6 -s "Cubetown.sqlite" -n "NoBuild" -d "SystemFileNoBuild.PTS"
transit-6to7

CUBE 6 line text file (.lin)

CUBE 6 combined PT-HW network

CUBE 7 transit dataset Option will load CUBE 6 transit information into the CUBE 7 transit dataset in the database
"C:\Program Files\Bentley\CUBE7\CubeConvert.exe" -f transit-6to7 -s "LineFile.lin" -d "Cubetown.sqlite" -n "NoBuild" -t "transit"
transit-7to6 CUBE 7 database with transit dataset

CUBE 6 line text file (.lin)

Option converting the CUBE 7 transit dataset in a CUBE 6 line text file with or without associated system file.
"C:\Program Files\Bentley\CUBE7\CubeConvert.exe" -f transit-7to6 -s "Cubetown.sqlite" -n "NoBuild" -t "transit" -l "LineFile7to6.lin" -d "Cubetown_7to6.PTS"
"C:\Program Files\Bentley\CUBE7\CubeConvert.exe" -f transit-7to6 -s "Cubetown.sqlite" -n "NoBuild" -t "transit" -d "LineFile7to6.lin"
nonTransit-6to7

CUBE 6 non-transit text file (.ntl)

CUBE 6 combined PT-HW network

CUBE 7 non-transit dataset Option loading the CUBE 6 non-transit information into the CUBE7 transit dataset in the database
"C:\Program Files\Bentley\CUBE7\CubeConvert.exe" -f nonTransit-6to7 -n "NoBuild" -x "non_transit" -s "NTLOADS.NTL" -d "Cubetown.sqlite"  
nonTransit-7to6 CUBE 7 non-transit dataset CUBE 6 non-transit text file (.ntl) Option converting the CUBE 7 transit dataset in a CUBE 6 non-transit leg file.
"C:\Program Files\Bentley\CUBE7\CubeConvert.exe" -f nonTransit-7to6 -n "NoBuild" -x "non_transit" -s "Cubetown.sqlite" -d "Cubetown_NTLOADS.ntl"
toll-6to7 Toll dataset CUBE 7 database with toll dataset Option loading toll information into a CUBE 7 toll dataset in the database
"C:\Program Files\Bentley\CUBE7\CubeConvert.exe" -f toll-6to7 -n "AM" -o "toll_set" -s "Distance_Toll_Matrix_AM.csv" -d "Transurban.sqlite" 
toll-7to6 CUBE 7 database with toll dataset Text file will toll data Option converting the toll dataset in the CUBE 7 database in a text file with the toll data
"C:\Program Files\Bentley\CUBE7\CubeConvert.exe" -f toll-7to6 -n "AM" -o "toll_set" -s "Transurban.sqlite" -d "Transurban_TollSet.txt"
junction-6to7 CUBE 6 junction (.ind) file CUBE7 database with junction dataset Option loading junction information in a junction dataset in the CUBE 7 database
"C:\Program Files\Bentley\CUBE7\CubeConvert.exe" -f junction-6to7 -n "NoBuild" -j "NoBuild_Intersections" -s "NoBuild_Intersections.ind" -d "Cubetown.sqlite"
junction-7to6 CUBE 7 database with junction dataset CUBE 6 junction (.ind )file Option converting the junction dataset in a CUBE 6 junction(.ind) text file
"C:\Program Files\Bentley\CUBE7\CubeConvert.exe" -f junction-7to6 -n "NoBuild" -j "NoBuild_Intersections" -s "Cubetown.sqlite" -d "Cubetown_Intersections.ind"
turnpenalty-6to7 CUBE 6 turn penalty (.dat) file CUBE 7 turn penalty dataset Option adding a turn penalty dataset to the CUBE 7 database
"C:\Program Files\Bentley\CUBE7\CubeConvert.exe" -f turnpenalty-6to7 -n "2014" -p "turn_penalty_set" -s "trnpen.dat" -d "MWCOG.sqlite"
turnpenalty-7to6 CUBE 7 database with turn penalty dataset Penalty (.pen) file with turn penalty data Option converting the turn penalty dataset in a CUBE 6 turn penalty (.pen) text file
"C:\Program Files\Bentley\CUBE7\CubeConvert.exe" -f turnpenalty-7to6 -n "2014" -p "turn_penalty_set" -s "MWCOG.sqlite" -d "MWCOG_TurnPenalties.pen"
zonal-reference CUBE 7 matrix file (.cube-matrix)

Zonal reference name

Text file containing the zone labels for the specified zonal reference Option retrieving all the Zone labels assigned to a C7 matrix to a text file
"C:\Program Files\Bentley\CUBE7\CubeConvert.exe" -f zonal-reference -z "Sub Regions" -s "HighwaySkims.cube-matrix" -d "MWCOG_zonalreferences.txt"